﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace DataTier
{
    public class Expense
    {
                                       // Sap name  / sap column placement

        public string id { get; set; } // ID / 0
        public string pspnr_ext { get; set; } //PSPNR_EXT / 1
        public string posID { get; set; } //POSID / 2
        public string wbs { get; set; } // POST1 / 3
        public string convCurrency { get; set; } //CONV_CURRENCY / 4
        public string convAmount { get; set; } // CONV_AMNT / 5
        public string projectDefinition { get; set; } //PROJECT_PSPID / 6
        public string shortDescription { get; set; } //PROJECT_POST1 / 7
        public string firstName { get; set; } //EMPL_FIRST_NAME / 8
        public string middleName { get; set; } //EMPL_MIDDLE_NAME / 9
        public string lastName { get; set; } //EMPL_LAST_NAME /10
        public string expenseDescription { get; set; } //EXP_DESCR / 11
        public string isLocked { get; set; } //IS_LOCK / 12
        public string createDate { get; set; } //CREATE_DATE / 13
        public string days { get; set; } //DAYS_NUM / 14
        public string hours { get; set; } //HOURS_NUM / 15
        public string deleteIndicator { get; set; } //DELETE_INDICATOR / 16
        public string isChanged { get; set; } //IS_CHANGED / 17
        public string isBilled { get; set; } //IS_BILLING / 18
        public string approved { get; set; } //APPR / 19
        public string reject { get; set; } //REJECT / 20
        public string reviewed { get; set; } // REVIEWED / 21
        public string paid { get; set; } // PAID / 22
        public string prepaid { get; set; } //PREV_PAID / 23
        public string expenseIndicator { get; set; } //EXP_IND / 24
        public string transfered { get; set; } //TRANSFERED / 25
        public string paidDate { get; set; } // PAID_DAY / 26
        public string transferDate { get; set; } //TRANSF_DATE / 27
        public string receiptNr { get; set; } //RECEIPT_NUM / 28
        public string expenseDate { get; set; } //DEXP / 29
        public int empID { get; set; } //EMPID / 30
        public int pspNR { get; set; } //PSPNR / 31
        public int pspHI { get; set; } //PSPHI / 32
        public string sRule { get; set; } //SRULE / 33
        public string amount { get; set; } //AMNT / 34
        public string descr { get; set; } //DESCR / 35
        public string fromDescription { get; set; } //FROM_DESC / 36
        public string toDescription { get; set; } //TO_DESC / 37
        public string expenseType { get; set; }  //EXPENSE_TYPE  / 38
        public double distance { get; set; } //DISTANCE / 39
        public string origCurrency { get; set; } //ORIG_CURRENCY / 40
        public string changeDate { get; set; } //CHANGE_DATE / 41
        public int changeBy { get; set; } //CHANGE_BY / 42
        public int expSubtype { get; set; } //EXP_SUBTYPE / 43
        public string country { get; set; } //COUNTRY / 44
        public string city { get; set; } //CITY / 45
        public string hotel { get; set; } //HOTEL / 46
        public string fromDate { get; set; } //FROM_DATE / 47
        public string toDate { get; set; } //TO_DATE / 48
        public string startDate { get; set; } //START_DATE / 49
        public string endDate { get; set; } //END_DATE / 50
        public string startTime { get; set; } //START_TIME / 51
        public string endTime { get; set; } //END_TIME / 52
        public string description { get; set; } //DESCRIPTION / 53
        public int typeNumber { get; set; } //TYPE_NUMBER / 54
        public int subtypeNumber { get; set; } //SUBTYPE_NUMBER / 55
        public string pictureURL { get; set; } //PDF File URL

        public Expense() { }
    }
}
